 

#region Copyright Statement
//////////////////////////////////////////////
//	ORMAC
//  By: Ali Ghomi (2011)
//////////////////////////////////////////////
#endregion

#region using
using System;
using System.Collections.Generic;
using ORMAC;
using ORMAC.Attributes;
using System.Runtime.Serialization;
#endregion

namespace Test
{
	/// <summary>
	/// Auto generated class by ORMAC from Orders table
	/// </summary>
	[Table("Orders")]
	[DataContract]
	public class OOrders
	{
		/// <summary>
		/// Auto generated property by ORMAC from OrderID column
		/// </summary>		
		[PrimaryKey]
		[Field("OrderID")]
		[DataMember]
		public int OrderID{
			get;
			set;
		}
		/// <summary>
		/// Auto generated property by ORMAC from CustomerID column
		/// </summary>		
		[Field("CustomerID")]
		[DataMember]
		public string CustomerID{
			get;
			set;
		}
		/// <summary>
		/// Auto generated property by ORMAC from EmployeeID column
		/// </summary>		
		[Field("EmployeeID")]
		[DataMember]
		public int EmployeeID{
			get;
			set;
		}
		/// <summary>
		/// Auto generated property by ORMAC from OrderDate column
		/// </summary>		
		[Field("OrderDate")]
		[DataMember]
		public DateTime OrderDate{
			get;
			set;
		}
		/// <summary>
		/// Auto generated property by ORMAC from RequiredDate column
		/// </summary>		
		[Field("RequiredDate")]
		[DataMember]
		public DateTime RequiredDate{
			get;
			set;
		}
		/// <summary>
		/// Auto generated property by ORMAC from ShippedDate column
		/// </summary>		
		[Field("ShippedDate")]
		[DataMember]
		public DateTime ShippedDate{
			get;
			set;
		}
		/// <summary>
		/// Auto generated property by ORMAC from ShipVia column
		/// </summary>		
		[Field("ShipVia")]
		[DataMember]
		public int ShipVia{
			get;
			set;
		}
		/// <summary>
		/// Auto generated property by ORMAC from Freight column
		/// </summary>		
		[Field("Freight")]
		[DataMember]
		public decimal Freight{
			get;
			set;
		}
		/// <summary>
		/// Auto generated property by ORMAC from ShipName column
		/// </summary>		
		[Field("ShipName")]
		[DataMember]
		public string ShipName{
			get;
			set;
		}
		/// <summary>
		/// Auto generated property by ORMAC from ShipAddress column
		/// </summary>		
		[Field("ShipAddress")]
		[DataMember]
		public string ShipAddress{
			get;
			set;
		}
		/// <summary>
		/// Auto generated property by ORMAC from ShipCity column
		/// </summary>		
		[Field("ShipCity")]
		[DataMember]
		public string ShipCity{
			get;
			set;
		}
		/// <summary>
		/// Auto generated property by ORMAC from ShipRegion column
		/// </summary>		
		[Field("ShipRegion")]
		[DataMember]
		public string ShipRegion{
			get;
			set;
		}
		/// <summary>
		/// Auto generated property by ORMAC from ShipPostalCode column
		/// </summary>		
		[Field("ShipPostalCode")]
		[DataMember]
		public string ShipPostalCode{
			get;
			set;
		}
		/// <summary>
		/// Auto generated property by ORMAC from ShipCountry column
		/// </summary>		
		[Field("ShipCountry")]
		[DataMember]
		public string ShipCountry{
			get;
			set;
		}
		/// <summary>
		/// Auto generated class property by ORMAC using
		///OrderID as primary key and OrderID as foreign key in  OrderDetails table
		/// </summary>				
		[DataMember]
		[Join(ParentCol="OrderID",ChildCol="OrderID")]
		public List<OOrderDetails> OrderDetailss{
			get;
			set;
		}
		/// <summary>
		/// Auto generated class property by ORMAC using
		///CustomerID as foreign key and CustomerID as primary key in  Customers table
		/// </summary>				
		[DataMember]
		[Join(ParentCol="CustomerID",ChildCol="CustomerID")]
		public OCustomers Customers {
			get;
			set;
		}
		/// <summary>
		/// Auto generated class property by ORMAC using
		///EmployeeID as foreign key and EmployeeID as primary key in  Employees table
		/// </summary>				
		[DataMember]
		[Join(ParentCol="EmployeeID",ChildCol="EmployeeID")]
		public OEmployees Employees {
			get;
			set;
		}
		/// <summary>
		/// Auto generated class property by ORMAC using
		///ShipVia as foreign key and ShipperID as primary key in  Shippers table
		/// </summary>				
		[DataMember]
		[Join(ParentCol="ShipVia",ChildCol="ShipperID")]
		public OShippers Shippers {
			get;
			set;
		}

	}
}
